﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace simpleHotel.Business
{
    public class Provinces
    {
        public List<simpleHotel.Business.Province> getProvinces() 
        {
            var data = (from province in Singleton.DataContext.Provinces
                    join tourNotebook in Singleton.DataContext.TourNotebooks
                 on province.ID equals tourNotebook.ID
                 select province).Distinct().ToList();

            return data;
        }
    }
}
